# -*- coding: utf-8 -*-
# @Time        :2025/3/4 21:07
# @Author      :文刀水寿
# @File        : pandas1.py
"""
 @Description :
"""
# https://movie.douban.com/j/chart/top_list?type=5&interval_id=100%3A90&action=&
# start=20&limit=20
# https://movie.douban.com/j/chart/top_list?type=5&interval_id=100%3A90&action=&
# start=40&limit=20

# 下载豆瓣电影前十页的数据
# 1.请求对象的定制
# 2.获取响应数据
# 3.下载数据

import urllib.request
import urllib.parse
import pandas as pd


def create_request(page):
    base_url = 'https://movie.douban.com/j/chart/top_list?type=5&interval_id=100%3A90&action=&'

    headers = {
        'user-agent': 'Mozilla/5.0 (Linux; Android 6.0; Nexus 5 Build/MRA58N) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Mobile Safari/537.36 Edg/133.0.0.0'
    }

    data = {
        'start': (page - 1) * 20,
        'limit': 20
    }

    data = urllib.parse.urlencode(data)
    url = base_url + data

    request = urllib.request.Request(url=url, headers=headers)
    return request


def get_content(request):
    response = urllib.request.urlopen(request)
    content = response.read().decode('utf8')
    return content


def down_load(page, content):
    # 打印 content 的内容以调试
    print("Content:", content)

    # 创建 DataFrame
    df = pd.DataFrame()
    print(type(content))
    # 保存到 Excel 文件
    df.to_excel(f"page_{page}.xlsx", index=False)
    print(f"第 {page} 页数据已保存到 page_{page}.xlsx")


# 程序入口
if __name__ == '__main__':
    start_page = int(input('请输入起始的页码'))
    end_page = int(input('请输入结束的页码'))

    for page in range(start_page, end_page + 1):
        #        每一页都有自己的请求对象的定制
        request = create_request(page)
        #         获取每一页响应数据
        content = get_content(request)
        #         下载
        down_load(page, content)
